library(readr)
library(tidyverse)
library(readxl)
library(here)

#test where the top level of the project directory is 
here::here()
[1] "/Users/greganderson/codeclan_work/data_cleaning_project/task_4"
#use this to set the path to the data files
candy_2015 <- read_xlsx(here("raw_data/boing-boing-candy-2015.xlsx"))
candy_2016 <- read_xlsx(here("raw_data/boing-boing-candy-2016.xlsx"))
candy_2017 <- read_xlsx(here("raw_data/boing-boing-candy-2017.xlsx"))
New names:
* `` -> ...114
dim(candy_2015)
[1] 5630  124
dim(candy_2016)
[1] 1259  123
dim(candy_2017)
[1] 2460  120
names(candy_2015)
  [1] "Timestamp"                                                                                                        
  [2] "How old are you?"                                                                                                 
  [3] "Are you going actually going trick or treating yourself?"                                                         
  [4] "[Butterfinger]"                                                                                                   
  [5] "[100 Grand Bar]"                                                                                                  
  [6] "[Anonymous brown globs that come in black and orange wrappers]"                                                   
  [7] "[Any full-sized candy bar]"                                                                                       
  [8] "[Black Jacks]"                                                                                                    
  [9] "[Bonkers]"                                                                                                        
 [10] "[Bottle Caps]"                                                                                                    
 [11] "[Box’o’ Raisins]"                                                                                                 
 [12] "[Brach products (not including candy corn)]"                                                                      
 [13] "[Bubble Gum]"                                                                                                     
 [14] "[Cadbury Creme Eggs]"                                                                                             
 [15] "[Candy Corn]"                                                                                                     
 [16] "[Vials of pure high fructose corn syrup, for main-lining into your vein]"                                         
 [17] "[Candy that is clearly just the stuff given out for free at restaurants]"                                         
 [18] "[Cash, or other forms of legal tender]"                                                                           
 [19] "[Chiclets]"                                                                                                       
 [20] "[Caramellos]"                                                                                                     
 [21] "[Snickers]"                                                                                                       
 [22] "[Dark Chocolate Hershey]"                                                                                         
 [23] "[Dental paraphenalia]"                                                                                            
 [24] "[Dots]"                                                                                                           
 [25] "[Fuzzy Peaches]"                                                                                                  
 [26] "[Generic Brand Acetaminophen]"                                                                                    
 [27] "[Glow sticks]"                                                                                                    
 [28] "[Broken glow stick]"                                                                                              
 [29] "[Goo Goo Clusters]"                                                                                               
 [30] "[Good N' Plenty]"                                                                                                 
 [31] "[Gum from baseball cards]"                                                                                        
 [32] "[Gummy Bears straight up]"                                                                                        
 [33] "[Creepy Religious comics/Chick Tracts]"                                                                           
 [34] "[Healthy Fruit]"                                                                                                  
 [35] "[Heath Bar]"                                                                                                      
 [36] "[Hershey’s Kissables]"                                                                                            
 [37] "[Hershey’s Milk Chocolate]"                                                                                       
 [38] "[Hugs (actual physical hugs)]"                                                                                    
 [39] "[Jolly Rancher (bad flavor)]"                                                                                     
 [40] "[Jolly Ranchers (good flavor)]"                                                                                   
 [41] "[Kale smoothie]"                                                                                                  
 [42] "[Kinder Happy Hippo]"                                                                                             
 [43] "[Kit Kat]"                                                                                                        
 [44] "[Hard Candy]"                                                                                                     
 [45] "[Lapel Pins]"                                                                                                     
 [46] "[LemonHeads]"                                                                                                     
 [47] "[Licorice]"                                                                                                       
 [48] "[Licorice (not black)]"                                                                                           
 [49] "[Lindt Truffle]"                                                                                                  
 [50] "[Lollipops]"                                                                                                      
 [51] "[Mars]"                                                                                                           
 [52] "[Mary Janes]"                                                                                                     
 [53] "[Maynards]"                                                                                                       
 [54] "[Milk Duds]"                                                                                                      
 [55] "[LaffyTaffy]"                                                                                                     
 [56] "[Minibags of chips]"                                                                                              
 [57] "[JoyJoy (Mit Iodine)]"                                                                                            
 [58] "[Reggie Jackson Bar]"                                                                                             
 [59] "[Pixy Stix]"                                                                                                      
 [60] "[Nerds]"                                                                                                          
 [61] "[Nestle Crunch]"                                                                                                  
 [62] "[Now'n'Laters]"                                                                                                   
 [63] "[Pencils]"                                                                                                        
 [64] "[Milky Way]"                                                                                                      
 [65] "[Reese’s Peanut Butter Cups]"                                                                                     
 [66] "[Tolberone something or other]"                                                                                   
 [67] "[Runts]"                                                                                                          
 [68] "[Junior Mints]"                                                                                                   
 [69] "[Senior Mints]"                                                                                                   
 [70] "[Mint Kisses]"                                                                                                    
 [71] "[Mint Juleps]"                                                                                                    
 [72] "[Mint Leaves]"                                                                                                    
 [73] "[Peanut M&M’s]"                                                                                                   
 [74] "[Regular M&Ms]"                                                                                                   
 [75] "[Mint M&Ms]"                                                                                                      
 [76] "[Ribbon candy]"                                                                                                   
 [77] "[Rolos]"                                                                                                          
 [78] "[Skittles]"                                                                                                       
 [79] "[Smarties (American)]"                                                                                            
 [80] "[Smarties (Commonwealth)]"                                                                                        
 [81] "[Chick-o-Sticks (we don’t know what that is)]"                                                                    
 [82] "[Spotted Dick]"                                                                                                   
 [83] "[Starburst]"                                                                                                      
 [84] "[Swedish Fish]"                                                                                                   
 [85] "[Sweetums]"                                                                                                       
 [86] "[Those odd marshmallow circus peanut things]"                                                                     
 [87] "[Three Musketeers]"                                                                                               
 [88] "[Peterson Brand Sidewalk Chalk]"                                                                                  
 [89] "[Peanut Butter Bars]"                                                                                             
 [90] "[Peanut Butter Jars]"                                                                                             
 [91] "[Trail Mix]"                                                                                                      
 [92] "[Twix]"                                                                                                           
 [93] "[Vicodin]"                                                                                                        
 [94] "[White Bread]"                                                                                                    
 [95] "[Whole Wheat anything]"                                                                                           
 [96] "[York Peppermint Patties]"                                                                                        
 [97] "Please leave any remarks or comments regarding your choices."                                                     
 [98] "Please list any items not included above that give you JOY."                                                      
 [99] "Please list any items not included above that give you DESPAIR."                                                  
[100] "Guess the number of mints in my hand."                                                                            
[101] "Betty or Veronica?"                                                                                               
[102] "Check all that apply: \"I cried tears of sadness at the end of  ____________\""                                   
[103] "\"That dress* that went viral early this year - when I first saw it, it was ________\""                           
[104] "Fill in the blank: \"Taylor Swift is a force for ___________\""                                                   
[105] "What is your favourite font?"                                                                                     
[106] "If you squint really hard, the words \"Intelligent Design\" would look like."                                     
[107] "Fill in the blank: \"Imitation is a form of ____________\""                                                       
[108] "Please estimate the degree(s) of separation you have from the following celebrities [JK Rowling]"                 
[109] "Please estimate the degree(s) of separation you have from the following celebrities [JJ Abrams]"                  
[110] "Please estimate the degree(s) of separation you have from the following celebrities [Beyoncé]"                    
[111] "Please estimate the degree(s) of separation you have from the following celebrities [Bieber]"                     
[112] "Please estimate the degree(s) of separation you have from the following celebrities [Kevin Bacon]"                
[113] "Please estimate the degree(s) of separation you have from the following celebrities [Francis Bacon (1561 - 1626)]"
[114] "[Sea-salt flavored stuff, probably chocolate, since this is the \"it\" flavor of the year]"                       
[115] "[Necco Wafers]"                                                                                                   
[116] "Which day do you prefer, Friday or Sunday?"                                                                       
[117] "Please estimate the degrees of separation you have from the following folks [Bruce Lee]"                          
[118] "Please estimate the degrees of separation you have from the following folks [JK Rowling]"                         
[119] "Please estimate the degrees of separation you have from the following folks [Malala Yousafzai]"                   
[120] "Please estimate the degrees of separation you have from the following folks [Thom Yorke]"                         
[121] "Please estimate the degrees of separation you have from the following folks [JJ Abrams]"                          
[122] "Please estimate the degrees of separation you have from the following folks [Hillary Clinton]"                    
[123] "Please estimate the degrees of separation you have from the following folks [Donald Trump]"                       
[124] "Please estimate the degrees of separation you have from the following folks [Beyoncé Knowles]"                    
names(candy_2016)
  [1] "Timestamp"                                                                                                                                
  [2] "Are you going actually going trick or treating yourself?"                                                                                 
  [3] "Your gender:"                                                                                                                             
  [4] "How old are you?"                                                                                                                         
  [5] "Which country do you live in?"                                                                                                            
  [6] "Which state, province, county do you live in?"                                                                                            
  [7] "[100 Grand Bar]"                                                                                                                          
  [8] "[Anonymous brown globs that come in black and orange wrappers]"                                                                           
  [9] "[Any full-sized candy bar]"                                                                                                               
 [10] "[Black Jacks]"                                                                                                                            
 [11] "[Bonkers (the candy)]"                                                                                                                    
 [12] "[Bonkers (the board game)]"                                                                                                               
 [13] "[Bottle Caps]"                                                                                                                            
 [14] "[Box'o'Raisins]"                                                                                                                          
 [15] "[Broken glow stick]"                                                                                                                      
 [16] "[Butterfinger]"                                                                                                                           
 [17] "[Cadbury Creme Eggs]"                                                                                                                     
 [18] "[Candy Corn]"                                                                                                                             
 [19] "[Candy that is clearly just the stuff given out for free at restaurants]"                                                                 
 [20] "[Caramellos]"                                                                                                                             
 [21] "[Cash, or other forms of legal tender]"                                                                                                   
 [22] "[Chardonnay]"                                                                                                                             
 [23] "[Chick-o-Sticks (we don’t know what that is)]"                                                                                            
 [24] "[Chiclets]"                                                                                                                               
 [25] "[Coffee Crisp]"                                                                                                                           
 [26] "[Creepy Religious comics/Chick Tracts]"                                                                                                   
 [27] "[Dental paraphenalia]"                                                                                                                    
 [28] "[Dots]"                                                                                                                                   
 [29] "[Dove Bars]"                                                                                                                              
 [30] "[Fuzzy Peaches]"                                                                                                                          
 [31] "[Generic Brand Acetaminophen]"                                                                                                            
 [32] "[Glow sticks]"                                                                                                                            
 [33] "[Goo Goo Clusters]"                                                                                                                       
 [34] "[Good N' Plenty]"                                                                                                                         
 [35] "[Gum from baseball cards]"                                                                                                                
 [36] "[Gummy Bears straight up]"                                                                                                                
 [37] "[Hard Candy]"                                                                                                                             
 [38] "[Healthy Fruit]"                                                                                                                          
 [39] "[Heath Bar]"                                                                                                                              
 [40] "[Hershey's Dark Chocolate]"                                                                                                               
 [41] "[Hershey’s Milk Chocolate]"                                                                                                               
 [42] "[Hershey's Kisses]"                                                                                                                       
 [43] "[Hugs (actual physical hugs)]"                                                                                                            
 [44] "[Jolly Rancher (bad flavor)]"                                                                                                             
 [45] "[Jolly Ranchers (good flavor)]"                                                                                                           
 [46] "[JoyJoy (Mit Iodine!)]"                                                                                                                   
 [47] "[Junior Mints]"                                                                                                                           
 [48] "[Senior Mints]"                                                                                                                           
 [49] "[Kale smoothie]"                                                                                                                          
 [50] "[Kinder Happy Hippo]"                                                                                                                     
 [51] "[Kit Kat]"                                                                                                                                
 [52] "[LaffyTaffy]"                                                                                                                             
 [53] "[LemonHeads]"                                                                                                                             
 [54] "[Licorice (not black)]"                                                                                                                   
 [55] "[Licorice (yes black)]"                                                                                                                   
 [56] "[Lindt Truffle]"                                                                                                                          
 [57] "[Lollipops]"                                                                                                                              
 [58] "[Mars]"                                                                                                                                   
 [59] "[Mary Janes]"                                                                                                                             
 [60] "[Maynards]"                                                                                                                               
 [61] "[Mike and Ike]"                                                                                                                           
 [62] "[Milk Duds]"                                                                                                                              
 [63] "[Milky Way]"                                                                                                                              
 [64] "[Regular M&Ms]"                                                                                                                           
 [65] "[Peanut M&M’s]"                                                                                                                           
 [66] "[Blue M&M's]"                                                                                                                             
 [67] "[Red M&M's]"                                                                                                                              
 [68] "[Third Party M&M's]"                                                                                                                      
 [69] "[Minibags of chips]"                                                                                                                      
 [70] "[Mint Kisses]"                                                                                                                            
 [71] "[Mint Juleps]"                                                                                                                            
 [72] "[Mr. Goodbar]"                                                                                                                            
 [73] "[Necco Wafers]"                                                                                                                           
 [74] "[Nerds]"                                                                                                                                  
 [75] "[Nestle Crunch]"                                                                                                                          
 [76] "[Now'n'Laters]"                                                                                                                           
 [77] "[Peeps]"                                                                                                                                  
 [78] "[Pencils]"                                                                                                                                
 [79] "[Person of Interest Season 3 DVD Box Set (not including Disc 4 with hilarious outtakes)]"                                                 
 [80] "[Pixy Stix]"                                                                                                                              
 [81] "[Reese’s Peanut Butter Cups]"                                                                                                             
 [82] "[Reese's Pieces]"                                                                                                                         
 [83] "[Reggie Jackson Bar]"                                                                                                                     
 [84] "[Rolos]"                                                                                                                                  
 [85] "[Skittles]"                                                                                                                               
 [86] "[Smarties (American)]"                                                                                                                    
 [87] "[Smarties (Commonwealth)]"                                                                                                                
 [88] "[Snickers]"                                                                                                                               
 [89] "[Sourpatch Kids (i.e. abominations of nature)]"                                                                                           
 [90] "[Spotted Dick]"                                                                                                                           
 [91] "[Starburst]"                                                                                                                              
 [92] "[Sweet Tarts]"                                                                                                                            
 [93] "[Swedish Fish]"                                                                                                                           
 [94] "[Sweetums (a friend to diabetes)]"                                                                                                        
 [95] "[Tic Tacs]"                                                                                                                               
 [96] "[Those odd marshmallow circus peanut things]"                                                                                             
 [97] "[Three Musketeers]"                                                                                                                       
 [98] "[Tolberone something or other]"                                                                                                           
 [99] "[Trail Mix]"                                                                                                                              
[100] "[Twix]"                                                                                                                                   
[101] "[Vials of pure high fructose corn syrup, for main-lining into your vein]"                                                                 
[102] "[Vicodin]"                                                                                                                                
[103] "[Whatchamacallit Bars]"                                                                                                                   
[104] "[White Bread]"                                                                                                                            
[105] "[Whole Wheat anything]"                                                                                                                   
[106] "[York Peppermint Patties]"                                                                                                                
[107] "Please list any items not included above that give you JOY."                                                                              
[108] "Please list any items not included above that give you DESPAIR."                                                                          
[109] "Please leave any witty, snarky or thoughtful remarks or comments regarding your choices."                                                 
[110] "Guess the number of mints in my hand."                                                                                                    
[111] "Betty or Veronica?"                                                                                                                       
[112] "\"That dress* that went viral a few years back - when I first saw it, it was ________\""                                                  
[113] "What is your favourite font?"                                                                                                             
[114] "Please estimate the degree(s) of separation you have from the following celebrities [JK Rowling]"                                         
[115] "Please estimate the degree(s) of separation you have from the following celebrities [JJ Abrams]"                                          
[116] "Please estimate the degree(s) of separation you have from the following celebrities [Beyoncé]"                                            
[117] "Please estimate the degree(s) of separation you have from the following celebrities [Bieber]"                                             
[118] "Please estimate the degree(s) of separation you have from the following celebrities [Kevin Bacon]"                                        
[119] "Please estimate the degree(s) of separation you have from the following celebrities [Francis Bacon (1561 - 1626)]"                        
[120] "Which day do you prefer, Friday or Sunday?"                                                                                               
[121] "Do you eat apples the correct way, East to West (side to side) or do you eat them like a freak of nature, South to North (bottom to top)?"
[122] "When you see the above image of the 4 different websites, which one would you most likely check out (please be honest)."                  
[123] "[York Peppermint Patties] Ignore"                                                                                                         
names(candy_2017)
  [1] "Internal ID"                                                                           
  [2] "Q1: GOING OUT?"                                                                        
  [3] "Q2: GENDER"                                                                            
  [4] "Q3: AGE"                                                                               
  [5] "Q4: COUNTRY"                                                                           
  [6] "Q5: STATE, PROVINCE, COUNTY, ETC"                                                      
  [7] "Q6 | 100 Grand Bar"                                                                    
  [8] "Q6 | Anonymous brown globs that come in black and orange wrappers\t(a.k.a. Mary Janes)"
  [9] "Q6 | Any full-sized candy bar"                                                         
 [10] "Q6 | Black Jacks"                                                                      
 [11] "Q6 | Bonkers (the candy)"                                                              
 [12] "Q6 | Bonkers (the board game)"                                                         
 [13] "Q6 | Bottle Caps"                                                                      
 [14] "Q6 | Box'o'Raisins"                                                                    
 [15] "Q6 | Broken glow stick"                                                                
 [16] "Q6 | Butterfinger"                                                                     
 [17] "Q6 | Cadbury Creme Eggs"                                                               
 [18] "Q6 | Candy Corn"                                                                       
 [19] "Q6 | Candy that is clearly just the stuff given out for free at restaurants"           
 [20] "Q6 | Caramellos"                                                                       
 [21] "Q6 | Cash, or other forms of legal tender"                                             
 [22] "Q6 | Chardonnay"                                                                       
 [23] "Q6 | Chick-o-Sticks (we don’t know what that is)"                                      
 [24] "Q6 | Chiclets"                                                                         
 [25] "Q6 | Coffee Crisp"                                                                     
 [26] "Q6 | Creepy Religious comics/Chick Tracts"                                             
 [27] "Q6 | Dental paraphenalia"                                                              
 [28] "Q6 | Dots"                                                                             
 [29] "Q6 | Dove Bars"                                                                        
 [30] "Q6 | Fuzzy Peaches"                                                                    
 [31] "Q6 | Generic Brand Acetaminophen"                                                      
 [32] "Q6 | Glow sticks"                                                                      
 [33] "Q6 | Goo Goo Clusters"                                                                 
 [34] "Q6 | Good N' Plenty"                                                                   
 [35] "Q6 | Gum from baseball cards"                                                          
 [36] "Q6 | Gummy Bears straight up"                                                          
 [37] "Q6 | Hard Candy"                                                                       
 [38] "Q6 | Healthy Fruit"                                                                    
 [39] "Q6 | Heath Bar"                                                                        
 [40] "Q6 | Hershey's Dark Chocolate"                                                         
 [41] "Q6 | Hershey’s Milk Chocolate"                                                         
 [42] "Q6 | Hershey's Kisses"                                                                 
 [43] "Q6 | Hugs (actual physical hugs)"                                                      
 [44] "Q6 | Jolly Rancher (bad flavor)"                                                       
 [45] "Q6 | Jolly Ranchers (good flavor)"                                                     
 [46] "Q6 | JoyJoy (Mit Iodine!)"                                                             
 [47] "Q6 | Junior Mints"                                                                     
 [48] "Q6 | Senior Mints"                                                                     
 [49] "Q6 | Kale smoothie"                                                                    
 [50] "Q6 | Kinder Happy Hippo"                                                               
 [51] "Q6 | Kit Kat"                                                                          
 [52] "Q6 | LaffyTaffy"                                                                       
 [53] "Q6 | LemonHeads"                                                                       
 [54] "Q6 | Licorice (not black)"                                                             
 [55] "Q6 | Licorice (yes black)"                                                             
 [56] "Q6 | Lindt Truffle"                                                                    
 [57] "Q6 | Lollipops"                                                                        
 [58] "Q6 | Mars"                                                                             
 [59] "Q6 | Maynards"                                                                         
 [60] "Q6 | Mike and Ike"                                                                     
 [61] "Q6 | Milk Duds"                                                                        
 [62] "Q6 | Milky Way"                                                                        
 [63] "Q6 | Regular M&Ms"                                                                     
 [64] "Q6 | Peanut M&M’s"                                                                     
 [65] "Q6 | Blue M&M's"                                                                       
 [66] "Q6 | Red M&M's"                                                                        
 [67] "Q6 | Green Party M&M's"                                                                
 [68] "Q6 | Independent M&M's"                                                                
 [69] "Q6 | Abstained from M&M'ing."                                                          
 [70] "Q6 | Minibags of chips"                                                                
 [71] "Q6 | Mint Kisses"                                                                      
 [72] "Q6 | Mint Juleps"                                                                      
 [73] "Q6 | Mr. Goodbar"                                                                      
 [74] "Q6 | Necco Wafers"                                                                     
 [75] "Q6 | Nerds"                                                                            
 [76] "Q6 | Nestle Crunch"                                                                    
 [77] "Q6 | Now'n'Laters"                                                                     
 [78] "Q6 | Peeps"                                                                            
 [79] "Q6 | Pencils"                                                                          
 [80] "Q6 | Pixy Stix"                                                                        
 [81] "Q6 | Real Housewives of Orange County Season 9 Blue-Ray"                               
 [82] "Q6 | Reese’s Peanut Butter Cups"                                                       
 [83] "Q6 | Reese's Pieces"                                                                   
 [84] "Q6 | Reggie Jackson Bar"                                                               
 [85] "Q6 | Rolos"                                                                            
 [86] "Q6 | Sandwich-sized bags filled with BooBerry Crunch"                                  
 [87] "Q6 | Skittles"                                                                         
 [88] "Q6 | Smarties (American)"                                                              
 [89] "Q6 | Smarties (Commonwealth)"                                                          
 [90] "Q6 | Snickers"                                                                         
 [91] "Q6 | Sourpatch Kids (i.e. abominations of nature)"                                     
 [92] "Q6 | Spotted Dick"                                                                     
 [93] "Q6 | Starburst"                                                                        
 [94] "Q6 | Sweet Tarts"                                                                      
 [95] "Q6 | Swedish Fish"                                                                     
 [96] "Q6 | Sweetums (a friend to diabetes)"                                                  
 [97] "Q6 | Take 5"                                                                           
 [98] "Q6 | Tic Tacs"                                                                         
 [99] "Q6 | Those odd marshmallow circus peanut things"                                       
[100] "Q6 | Three Musketeers"                                                                 
[101] "Q6 | Tolberone something or other"                                                     
[102] "Q6 | Trail Mix"                                                                        
[103] "Q6 | Twix"                                                                             
[104] "Q6 | Vials of pure high fructose corn syrup, for main-lining into your vein"           
[105] "Q6 | Vicodin"                                                                          
[106] "Q6 | Whatchamacallit Bars"                                                             
[107] "Q6 | White Bread"                                                                      
[108] "Q6 | Whole Wheat anything"                                                             
[109] "Q6 | York Peppermint Patties"                                                          
[110] "Q7: JOY OTHER"                                                                         
[111] "Q8: DESPAIR OTHER"                                                                     
[112] "Q9: OTHER COMMENTS"                                                                    
[113] "Q10: DRESS"                                                                            
[114] "...114"                                                                                
[115] "Q11: DAY"                                                                              
[116] "Q12: MEDIA [Daily Dish]"                                                               
[117] "Q12: MEDIA [Science]"                                                                  
[118] "Q12: MEDIA [ESPN]"                                                                     
[119] "Q12: MEDIA [Yahoo]"                                                                    
[120] "Click Coordinates (x, y)"                                                              
candy_2015
candy_2016
candy_2017
NA
# clean names
library(janitor)
# 2005
candy_2015_1 <- clean_names(candy_2015)
names(candy_2015_1)
  [1] "timestamp"                                                                                                 
  [2] "how_old_are_you"                                                                                           
  [3] "are_you_going_actually_going_trick_or_treating_yourself"                                                   
  [4] "butterfinger"                                                                                              
  [5] "x100_grand_bar"                                                                                            
  [6] "anonymous_brown_globs_that_come_in_black_and_orange_wrappers"                                              
  [7] "any_full_sized_candy_bar"                                                                                  
  [8] "black_jacks"                                                                                               
  [9] "bonkers"                                                                                                   
 [10] "bottle_caps"                                                                                               
 [11] "box_o_raisins"                                                                                             
 [12] "brach_products_not_including_candy_corn"                                                                   
 [13] "bubble_gum"                                                                                                
 [14] "cadbury_creme_eggs"                                                                                        
 [15] "candy_corn"                                                                                                
 [16] "vials_of_pure_high_fructose_corn_syrup_for_main_lining_into_your_vein"                                     
 [17] "candy_that_is_clearly_just_the_stuff_given_out_for_free_at_restaurants"                                    
 [18] "cash_or_other_forms_of_legal_tender"                                                                       
 [19] "chiclets"                                                                                                  
 [20] "caramellos"                                                                                                
 [21] "snickers"                                                                                                  
 [22] "dark_chocolate_hershey"                                                                                    
 [23] "dental_paraphenalia"                                                                                       
 [24] "dots"                                                                                                      
 [25] "fuzzy_peaches"                                                                                             
 [26] "generic_brand_acetaminophen"                                                                               
 [27] "glow_sticks"                                                                                               
 [28] "broken_glow_stick"                                                                                         
 [29] "goo_goo_clusters"                                                                                          
 [30] "good_n_plenty"                                                                                             
 [31] "gum_from_baseball_cards"                                                                                   
 [32] "gummy_bears_straight_up"                                                                                   
 [33] "creepy_religious_comics_chick_tracts"                                                                      
 [34] "healthy_fruit"                                                                                             
 [35] "heath_bar"                                                                                                 
 [36] "hershey_s_kissables"                                                                                       
 [37] "hershey_s_milk_chocolate"                                                                                  
 [38] "hugs_actual_physical_hugs"                                                                                 
 [39] "jolly_rancher_bad_flavor"                                                                                  
 [40] "jolly_ranchers_good_flavor"                                                                                
 [41] "kale_smoothie"                                                                                             
 [42] "kinder_happy_hippo"                                                                                        
 [43] "kit_kat"                                                                                                   
 [44] "hard_candy"                                                                                                
 [45] "lapel_pins"                                                                                                
 [46] "lemon_heads"                                                                                               
 [47] "licorice"                                                                                                  
 [48] "licorice_not_black"                                                                                        
 [49] "lindt_truffle"                                                                                             
 [50] "lollipops"                                                                                                 
 [51] "mars"                                                                                                      
 [52] "mary_janes"                                                                                                
 [53] "maynards"                                                                                                  
 [54] "milk_duds"                                                                                                 
 [55] "laffy_taffy"                                                                                               
 [56] "minibags_of_chips"                                                                                         
 [57] "joy_joy_mit_iodine"                                                                                        
 [58] "reggie_jackson_bar"                                                                                        
 [59] "pixy_stix"                                                                                                 
 [60] "nerds"                                                                                                     
 [61] "nestle_crunch"                                                                                             
 [62] "nown_laters"                                                                                               
 [63] "pencils"                                                                                                   
 [64] "milky_way"                                                                                                 
 [65] "reese_s_peanut_butter_cups"                                                                                
 [66] "tolberone_something_or_other"                                                                              
 [67] "runts"                                                                                                     
 [68] "junior_mints"                                                                                              
 [69] "senior_mints"                                                                                              
 [70] "mint_kisses"                                                                                               
 [71] "mint_juleps"                                                                                               
 [72] "mint_leaves"                                                                                               
 [73] "peanut_m_m_s"                                                                                              
 [74] "regular_m_ms"                                                                                              
 [75] "mint_m_ms"                                                                                                 
 [76] "ribbon_candy"                                                                                              
 [77] "rolos"                                                                                                     
 [78] "skittles"                                                                                                  
 [79] "smarties_american"                                                                                         
 [80] "smarties_commonwealth"                                                                                     
 [81] "chick_o_sticks_we_don_t_know_what_that_is"                                                                 
 [82] "spotted_dick"                                                                                              
 [83] "starburst"                                                                                                 
 [84] "swedish_fish"                                                                                              
 [85] "sweetums"                                                                                                  
 [86] "those_odd_marshmallow_circus_peanut_things"                                                                
 [87] "three_musketeers"                                                                                          
 [88] "peterson_brand_sidewalk_chalk"                                                                             
 [89] "peanut_butter_bars"                                                                                        
 [90] "peanut_butter_jars"                                                                                        
 [91] "trail_mix"                                                                                                 
 [92] "twix"                                                                                                      
 [93] "vicodin"                                                                                                   
 [94] "white_bread"                                                                                               
 [95] "whole_wheat_anything"                                                                                      
 [96] "york_peppermint_patties"                                                                                   
 [97] "please_leave_any_remarks_or_comments_regarding_your_choices"                                               
 [98] "please_list_any_items_not_included_above_that_give_you_joy"                                                
 [99] "please_list_any_items_not_included_above_that_give_you_despair"                                            
[100] "guess_the_number_of_mints_in_my_hand"                                                                      
[101] "betty_or_veronica"                                                                                         
[102] "check_all_that_apply_i_cried_tears_of_sadness_at_the_end_of"                                               
[103] "that_dress_that_went_viral_early_this_year_when_i_first_saw_it_it_was"                                     
[104] "fill_in_the_blank_taylor_swift_is_a_force_for"                                                             
[105] "what_is_your_favourite_font"                                                                               
[106] "if_you_squint_really_hard_the_words_intelligent_design_would_look_like"                                    
[107] "fill_in_the_blank_imitation_is_a_form_of"                                                                  
[108] "please_estimate_the_degree_s_of_separation_you_have_from_the_following_celebrities_jk_rowling"             
[109] "please_estimate_the_degree_s_of_separation_you_have_from_the_following_celebrities_jj_abrams"              
[110] "please_estimate_the_degree_s_of_separation_you_have_from_the_following_celebrities_beyonce"                
[111] "please_estimate_the_degree_s_of_separation_you_have_from_the_following_celebrities_bieber"                 
[112] "please_estimate_the_degree_s_of_separation_you_have_from_the_following_celebrities_kevin_bacon"            
[113] "please_estimate_the_degree_s_of_separation_you_have_from_the_following_celebrities_francis_bacon_1561_1626"
[114] "sea_salt_flavored_stuff_probably_chocolate_since_this_is_the_it_flavor_of_the_year"                        
[115] "necco_wafers"                                                                                              
[116] "which_day_do_you_prefer_friday_or_sunday"                                                                  
[117] "please_estimate_the_degrees_of_separation_you_have_from_the_following_folks_bruce_lee"                     
[118] "please_estimate_the_degrees_of_separation_you_have_from_the_following_folks_jk_rowling"                    
[119] "please_estimate_the_degrees_of_separation_you_have_from_the_following_folks_malala_yousafzai"              
[120] "please_estimate_the_degrees_of_separation_you_have_from_the_following_folks_thom_yorke"                    
[121] "please_estimate_the_degrees_of_separation_you_have_from_the_following_folks_jj_abrams"                     
[122] "please_estimate_the_degrees_of_separation_you_have_from_the_following_folks_hillary_clinton"               
[123] "please_estimate_the_degrees_of_separation_you_have_from_the_following_folks_donald_trump"                  
[124] "please_estimate_the_degrees_of_separation_you_have_from_the_following_folks_beyonce_knowles"               
# 2006
candy_2016_1 <- clean_names(candy_2016)
names(candy_2016_1)
  [1] "timestamp"                                                                                                                         
  [2] "are_you_going_actually_going_trick_or_treating_yourself"                                                                           
  [3] "your_gender"                                                                                                                       
  [4] "how_old_are_you"                                                                                                                   
  [5] "which_country_do_you_live_in"                                                                                                      
  [6] "which_state_province_county_do_you_live_in"                                                                                        
  [7] "x100_grand_bar"                                                                                                                    
  [8] "anonymous_brown_globs_that_come_in_black_and_orange_wrappers"                                                                      
  [9] "any_full_sized_candy_bar"                                                                                                          
 [10] "black_jacks"                                                                                                                       
 [11] "bonkers_the_candy"                                                                                                                 
 [12] "bonkers_the_board_game"                                                                                                            
 [13] "bottle_caps"                                                                                                                       
 [14] "boxo_raisins"                                                                                                                      
 [15] "broken_glow_stick"                                                                                                                 
 [16] "butterfinger"                                                                                                                      
 [17] "cadbury_creme_eggs"                                                                                                                
 [18] "candy_corn"                                                                                                                        
 [19] "candy_that_is_clearly_just_the_stuff_given_out_for_free_at_restaurants"                                                            
 [20] "caramellos"                                                                                                                        
 [21] "cash_or_other_forms_of_legal_tender"                                                                                               
 [22] "chardonnay"                                                                                                                        
 [23] "chick_o_sticks_we_don_t_know_what_that_is"                                                                                         
 [24] "chiclets"                                                                                                                          
 [25] "coffee_crisp"                                                                                                                      
 [26] "creepy_religious_comics_chick_tracts"                                                                                              
 [27] "dental_paraphenalia"                                                                                                               
 [28] "dots"                                                                                                                              
 [29] "dove_bars"                                                                                                                         
 [30] "fuzzy_peaches"                                                                                                                     
 [31] "generic_brand_acetaminophen"                                                                                                       
 [32] "glow_sticks"                                                                                                                       
 [33] "goo_goo_clusters"                                                                                                                  
 [34] "good_n_plenty"                                                                                                                     
 [35] "gum_from_baseball_cards"                                                                                                           
 [36] "gummy_bears_straight_up"                                                                                                           
 [37] "hard_candy"                                                                                                                        
 [38] "healthy_fruit"                                                                                                                     
 [39] "heath_bar"                                                                                                                         
 [40] "hersheys_dark_chocolate"                                                                                                           
 [41] "hershey_s_milk_chocolate"                                                                                                          
 [42] "hersheys_kisses"                                                                                                                   
 [43] "hugs_actual_physical_hugs"                                                                                                         
 [44] "jolly_rancher_bad_flavor"                                                                                                          
 [45] "jolly_ranchers_good_flavor"                                                                                                        
 [46] "joy_joy_mit_iodine"                                                                                                                
 [47] "junior_mints"                                                                                                                      
 [48] "senior_mints"                                                                                                                      
 [49] "kale_smoothie"                                                                                                                     
 [50] "kinder_happy_hippo"                                                                                                                
 [51] "kit_kat"                                                                                                                           
 [52] "laffy_taffy"                                                                                                                       
 [53] "lemon_heads"                                                                                                                       
 [54] "licorice_not_black"                                                                                                                
 [55] "licorice_yes_black"                                                                                                                
 [56] "lindt_truffle"                                                                                                                     
 [57] "lollipops"                                                                                                                         
 [58] "mars"                                                                                                                              
 [59] "mary_janes"                                                                                                                        
 [60] "maynards"                                                                                                                          
 [61] "mike_and_ike"                                                                                                                      
 [62] "milk_duds"                                                                                                                         
 [63] "milky_way"                                                                                                                         
 [64] "regular_m_ms"                                                                                                                      
 [65] "peanut_m_m_s"                                                                                                                      
 [66] "blue_m_ms"                                                                                                                         
 [67] "red_m_ms"                                                                                                                          
 [68] "third_party_m_ms"                                                                                                                  
 [69] "minibags_of_chips"                                                                                                                 
 [70] "mint_kisses"                                                                                                                       
 [71] "mint_juleps"                                                                                                                       
 [72] "mr_goodbar"                                                                                                                        
 [73] "necco_wafers"                                                                                                                      
 [74] "nerds"                                                                                                                             
 [75] "nestle_crunch"                                                                                                                     
 [76] "nown_laters"                                                                                                                       
 [77] "peeps"                                                                                                                             
 [78] "pencils"                                                                                                                           
 [79] "person_of_interest_season_3_dvd_box_set_not_including_disc_4_with_hilarious_outtakes"                                              
 [80] "pixy_stix"                                                                                                                         
 [81] "reese_s_peanut_butter_cups"                                                                                                        
 [82] "reeses_pieces"                                                                                                                     
 [83] "reggie_jackson_bar"                                                                                                                
 [84] "rolos"                                                                                                                             
 [85] "skittles"                                                                                                                          
 [86] "smarties_american"                                                                                                                 
 [87] "smarties_commonwealth"                                                                                                             
 [88] "snickers"                                                                                                                          
 [89] "sourpatch_kids_i_e_abominations_of_nature"                                                                                         
 [90] "spotted_dick"                                                                                                                      
 [91] "starburst"                                                                                                                         
 [92] "sweet_tarts"                                                                                                                       
 [93] "swedish_fish"                                                                                                                      
 [94] "sweetums_a_friend_to_diabetes"                                                                                                     
 [95] "tic_tacs"                                                                                                                          
 [96] "those_odd_marshmallow_circus_peanut_things"                                                                                        
 [97] "three_musketeers"                                                                                                                  
 [98] "tolberone_something_or_other"                                                                                                      
 [99] "trail_mix"                                                                                                                         
[100] "twix"                                                                                                                              
[101] "vials_of_pure_high_fructose_corn_syrup_for_main_lining_into_your_vein"                                                             
[102] "vicodin"                                                                                                                           
[103] "whatchamacallit_bars"                                                                                                              
[104] "white_bread"                                                                                                                       
[105] "whole_wheat_anything"                                                                                                              
[106] "york_peppermint_patties"                                                                                                           
[107] "please_list_any_items_not_included_above_that_give_you_joy"                                                                        
[108] "please_list_any_items_not_included_above_that_give_you_despair"                                                                    
[109] "please_leave_any_witty_snarky_or_thoughtful_remarks_or_comments_regarding_your_choices"                                            
[110] "guess_the_number_of_mints_in_my_hand"                                                                                              
[111] "betty_or_veronica"                                                                                                                 
[112] "that_dress_that_went_viral_a_few_years_back_when_i_first_saw_it_it_was"                                                            
[113] "what_is_your_favourite_font"                                                                                                       
[114] "please_estimate_the_degree_s_of_separation_you_have_from_the_following_celebrities_jk_rowling"                                     
[115] "please_estimate_the_degree_s_of_separation_you_have_from_the_following_celebrities_jj_abrams"                                      
[116] "please_estimate_the_degree_s_of_separation_you_have_from_the_following_celebrities_beyonce"                                        
[117] "please_estimate_the_degree_s_of_separation_you_have_from_the_following_celebrities_bieber"                                         
[118] "please_estimate_the_degree_s_of_separation_you_have_from_the_following_celebrities_kevin_bacon"                                    
[119] "please_estimate_the_degree_s_of_separation_you_have_from_the_following_celebrities_francis_bacon_1561_1626"                        
[120] "which_day_do_you_prefer_friday_or_sunday"                                                                                          
[121] "do_you_eat_apples_the_correct_way_east_to_west_side_to_side_or_do_you_eat_them_like_a_freak_of_nature_south_to_north_bottom_to_top"
[122] "when_you_see_the_above_image_of_the_4_different_websites_which_one_would_you_most_likely_check_out_please_be_honest"               
[123] "york_peppermint_patties_ignore"                                                                                                    
# 2007
candy_2017_1 <- clean_names(candy_2017)
names(candy_2017_1)
  [1] "internal_id"                                                                     
  [2] "q1_going_out"                                                                    
  [3] "q2_gender"                                                                       
  [4] "q3_age"                                                                          
  [5] "q4_country"                                                                      
  [6] "q5_state_province_county_etc"                                                    
  [7] "q6_100_grand_bar"                                                                
  [8] "q6_anonymous_brown_globs_that_come_in_black_and_orange_wrappers_a_k_a_mary_janes"
  [9] "q6_any_full_sized_candy_bar"                                                     
 [10] "q6_black_jacks"                                                                  
 [11] "q6_bonkers_the_candy"                                                            
 [12] "q6_bonkers_the_board_game"                                                       
 [13] "q6_bottle_caps"                                                                  
 [14] "q6_boxo_raisins"                                                                 
 [15] "q6_broken_glow_stick"                                                            
 [16] "q6_butterfinger"                                                                 
 [17] "q6_cadbury_creme_eggs"                                                           
 [18] "q6_candy_corn"                                                                   
 [19] "q6_candy_that_is_clearly_just_the_stuff_given_out_for_free_at_restaurants"       
 [20] "q6_caramellos"                                                                   
 [21] "q6_cash_or_other_forms_of_legal_tender"                                          
 [22] "q6_chardonnay"                                                                   
 [23] "q6_chick_o_sticks_we_don_t_know_what_that_is"                                    
 [24] "q6_chiclets"                                                                     
 [25] "q6_coffee_crisp"                                                                 
 [26] "q6_creepy_religious_comics_chick_tracts"                                         
 [27] "q6_dental_paraphenalia"                                                          
 [28] "q6_dots"                                                                         
 [29] "q6_dove_bars"                                                                    
 [30] "q6_fuzzy_peaches"                                                                
 [31] "q6_generic_brand_acetaminophen"                                                  
 [32] "q6_glow_sticks"                                                                  
 [33] "q6_goo_goo_clusters"                                                             
 [34] "q6_good_n_plenty"                                                                
 [35] "q6_gum_from_baseball_cards"                                                      
 [36] "q6_gummy_bears_straight_up"                                                      
 [37] "q6_hard_candy"                                                                   
 [38] "q6_healthy_fruit"                                                                
 [39] "q6_heath_bar"                                                                    
 [40] "q6_hersheys_dark_chocolate"                                                      
 [41] "q6_hershey_s_milk_chocolate"                                                     
 [42] "q6_hersheys_kisses"                                                              
 [43] "q6_hugs_actual_physical_hugs"                                                    
 [44] "q6_jolly_rancher_bad_flavor"                                                     
 [45] "q6_jolly_ranchers_good_flavor"                                                   
 [46] "q6_joy_joy_mit_iodine"                                                           
 [47] "q6_junior_mints"                                                                 
 [48] "q6_senior_mints"                                                                 
 [49] "q6_kale_smoothie"                                                                
 [50] "q6_kinder_happy_hippo"                                                           
 [51] "q6_kit_kat"                                                                      
 [52] "q6_laffy_taffy"                                                                  
 [53] "q6_lemon_heads"                                                                  
 [54] "q6_licorice_not_black"                                                           
 [55] "q6_licorice_yes_black"                                                           
 [56] "q6_lindt_truffle"                                                                
 [57] "q6_lollipops"                                                                    
 [58] "q6_mars"                                                                         
 [59] "q6_maynards"                                                                     
 [60] "q6_mike_and_ike"                                                                 
 [61] "q6_milk_duds"                                                                    
 [62] "q6_milky_way"                                                                    
 [63] "q6_regular_m_ms"                                                                 
 [64] "q6_peanut_m_m_s"                                                                 
 [65] "q6_blue_m_ms"                                                                    
 [66] "q6_red_m_ms"                                                                     
 [67] "q6_green_party_m_ms"                                                             
 [68] "q6_independent_m_ms"                                                             
 [69] "q6_abstained_from_m_ming"                                                        
 [70] "q6_minibags_of_chips"                                                            
 [71] "q6_mint_kisses"                                                                  
 [72] "q6_mint_juleps"                                                                  
 [73] "q6_mr_goodbar"                                                                   
 [74] "q6_necco_wafers"                                                                 
 [75] "q6_nerds"                                                                        
 [76] "q6_nestle_crunch"                                                                
 [77] "q6_nown_laters"                                                                  
 [78] "q6_peeps"                                                                        
 [79] "q6_pencils"                                                                      
 [80] "q6_pixy_stix"                                                                    
 [81] "q6_real_housewives_of_orange_county_season_9_blue_ray"                           
 [82] "q6_reese_s_peanut_butter_cups"                                                   
 [83] "q6_reeses_pieces"                                                                
 [84] "q6_reggie_jackson_bar"                                                           
 [85] "q6_rolos"                                                                        
 [86] "q6_sandwich_sized_bags_filled_with_boo_berry_crunch"                             
 [87] "q6_skittles"                                                                     
 [88] "q6_smarties_american"                                                            
 [89] "q6_smarties_commonwealth"                                                        
 [90] "q6_snickers"                                                                     
 [91] "q6_sourpatch_kids_i_e_abominations_of_nature"                                    
 [92] "q6_spotted_dick"                                                                 
 [93] "q6_starburst"                                                                    
 [94] "q6_sweet_tarts"                                                                  
 [95] "q6_swedish_fish"                                                                 
 [96] "q6_sweetums_a_friend_to_diabetes"                                                
 [97] "q6_take_5"                                                                       
 [98] "q6_tic_tacs"                                                                     
 [99] "q6_those_odd_marshmallow_circus_peanut_things"                                   
[100] "q6_three_musketeers"                                                             
[101] "q6_tolberone_something_or_other"                                                 
[102] "q6_trail_mix"                                                                    
[103] "q6_twix"                                                                         
[104] "q6_vials_of_pure_high_fructose_corn_syrup_for_main_lining_into_your_vein"        
[105] "q6_vicodin"                                                                      
[106] "q6_whatchamacallit_bars"                                                         
[107] "q6_white_bread"                                                                  
[108] "q6_whole_wheat_anything"                                                         
[109] "q6_york_peppermint_patties"                                                      
[110] "q7_joy_other"                                                                    
[111] "q8_despair_other"                                                                
[112] "q9_other_comments"                                                               
[113] "q10_dress"                                                                       
[114] "x114"                                                                            
[115] "q11_day"                                                                         
[116] "q12_media_daily_dish"                                                            
[117] "q12_media_science"                                                               
[118] "q12_media_espn"                                                                  
[119] "q12_media_yahoo"                                                                 
[120] "click_coordinates_x_y"                                                           
# wide to long format.  
candy_2015_2 <- candy_2015_1 %>%
  pivot_longer(cols = 4:96, 
               names_to = "candy_name", 
               values_to = "rating")

candy_2016_2 <- candy_2016_1 %>%
  pivot_longer(cols = 7:106,
   names_to = "candy_name", 
               values_to = "rating")

candy_2017_2 <- candy_2017_1 %>%
  pivot_longer(cols = 7:109,
   names_to = "candy_name", 
               values_to = "rating")
# drop unwanted columns

# 2015
candy_2015_3 <- candy_2015_2 %>%
  select(how_old_are_you, candy_name, rating, are_you_going_actually_going_trick_or_treating_yourself)

candy_2015_3

# 2016
candy_2016_3 <- candy_2016_2 %>%
  select(how_old_are_you, candy_name, rating, are_you_going_actually_going_trick_or_treating_yourself, which_country_do_you_live_in)

candy_2016_3

# 2017
candy_2017_3 <- candy_2017_2 %>%
  select(q3_age, candy_name, rating, q1_going_out, q4_country)

candy_2017_3
NA
NA
# Rename columns so that they align across the 3 years of data

# 2015
candy_2015_4 <- candy_2015_3 %>%
  rename(age = "how_old_are_you", 
        candy_name = "candy_name",
        rating = "rating",
        trick_or_treating = "are_you_going_actually_going_trick_or_treating_yourself") 
names(candy_2015_4)
[1] "age"               "candy_name"        "rating"            "trick_or_treating"
# 2016
candy_2016_4 <- candy_2016_3 %>%
  rename(age = "how_old_are_you", 
        candy_name = "candy_name",
        rating = "rating",
        trick_or_treating = "are_you_going_actually_going_trick_or_treating_yourself",
        country = "which_country_do_you_live_in")
names(candy_2016_4)
[1] "age"               "candy_name"        "rating"            "trick_or_treating"
[5] "country"          
# 2017
candy_2017_4 <- candy_2017_3 %>%
  rename(age = "q3_age", 
        candy_name = "candy_name",
        rating = "rating",
        trick_or_treating = "q1_going_out",
        country = "q4_country")
names(candy_2017_4)
[1] "age"               "candy_name"        "rating"            "trick_or_treating"
[5] "country"          
LS0tCnRpdGxlOiAiUiBOb3RlYm9vayIKb3V0cHV0OiBodG1sX25vdGVib29rCi0tLQoKYGBge3J9CmxpYnJhcnkocmVhZHIpCmxpYnJhcnkodGlkeXZlcnNlKQpsaWJyYXJ5KHJlYWR4bCkKYGBgCgpgYGB7cn0KbGlicmFyeShoZXJlKQoKI3Rlc3Qgd2hlcmUgdGhlIHRvcCBsZXZlbCBvZiB0aGUgcHJvamVjdCBkaXJlY3RvcnkgaXMgCmhlcmU6OmhlcmUoKQoKI3VzZSB0aGlzIHRvIHNldCB0aGUgcGF0aCB0byB0aGUgZGF0YSBmaWxlcwpjYW5keV8yMDE1IDwtIHJlYWRfeGxzeChoZXJlKCJyYXdfZGF0YS9ib2luZy1ib2luZy1jYW5keS0yMDE1Lnhsc3giKSkKY2FuZHlfMjAxNiA8LSByZWFkX3hsc3goaGVyZSgicmF3X2RhdGEvYm9pbmctYm9pbmctY2FuZHktMjAxNi54bHN4IikpCmNhbmR5XzIwMTcgPC0gcmVhZF94bHN4KGhlcmUoInJhd19kYXRhL2JvaW5nLWJvaW5nLWNhbmR5LTIwMTcueGxzeCIpKQoKYGBgCgoKYGBge3J9CmRpbShjYW5keV8yMDE1KQpkaW0oY2FuZHlfMjAxNikKZGltKGNhbmR5XzIwMTcpCmBgYAoKYGBge3J9Cm5hbWVzKGNhbmR5XzIwMTUpCm5hbWVzKGNhbmR5XzIwMTYpCm5hbWVzKGNhbmR5XzIwMTcpCmBgYAoKYGBge3J9CmNhbmR5XzIwMTUKY2FuZHlfMjAxNgpjYW5keV8yMDE3CmBgYAoKYGBge3J9CiMgY2xlYW4gbmFtZXMKCmxpYnJhcnkoamFuaXRvcikKIyAyMDA1CmNhbmR5XzIwMTVfMSA8LSBjbGVhbl9uYW1lcyhjYW5keV8yMDE1KQpuYW1lcyhjYW5keV8yMDE1XzEpCiMgMjAwNgpjYW5keV8yMDE2XzEgPC0gY2xlYW5fbmFtZXMoY2FuZHlfMjAxNikKbmFtZXMoY2FuZHlfMjAxNl8xKQojIDIwMDcKY2FuZHlfMjAxN18xIDwtIGNsZWFuX25hbWVzKGNhbmR5XzIwMTcpCm5hbWVzKGNhbmR5XzIwMTdfMSkKYGBgCgoKCmBgYHtyfQojIHdpZGUgdG8gbG9uZyBmb3JtYXQuICAKY2FuZHlfMjAxNV8yIDwtIGNhbmR5XzIwMTVfMSAlPiUKICBwaXZvdF9sb25nZXIoY29scyA9IDQ6OTYsIAogICAgICAgICAgICAgICBuYW1lc190byA9ICJjYW5keV9uYW1lIiwgCiAgICAgICAgICAgICAgIHZhbHVlc190byA9ICJyYXRpbmciKQoKY2FuZHlfMjAxNl8yIDwtIGNhbmR5XzIwMTZfMSAlPiUKICBwaXZvdF9sb25nZXIoY29scyA9IDc6MTA2LAogICBuYW1lc190byA9ICJjYW5keV9uYW1lIiwgCiAgICAgICAgICAgICAgIHZhbHVlc190byA9ICJyYXRpbmciKQoKY2FuZHlfMjAxN18yIDwtIGNhbmR5XzIwMTdfMSAlPiUKICBwaXZvdF9sb25nZXIoY29scyA9IDc6MTA5LAogICBuYW1lc190byA9ICJjYW5keV9uYW1lIiwgCiAgICAgICAgICAgICAgIHZhbHVlc190byA9ICJyYXRpbmciKQoKYGBgCgpgYGB7cn0KIyBkcm9wIHVud2FudGVkIGNvbHVtbnMKCiMgMjAxNQpjYW5keV8yMDE1XzMgPC0gY2FuZHlfMjAxNV8yICU+JQogIHNlbGVjdChob3dfb2xkX2FyZV95b3UsIGNhbmR5X25hbWUsIHJhdGluZywgYXJlX3lvdV9nb2luZ19hY3R1YWxseV9nb2luZ190cmlja19vcl90cmVhdGluZ195b3Vyc2VsZikKY2FuZHlfMjAxNV8zCgojIDIwMTYKY2FuZHlfMjAxNl8zIDwtIGNhbmR5XzIwMTZfMiAlPiUKICBzZWxlY3QoaG93X29sZF9hcmVfeW91LCBjYW5keV9uYW1lLCByYXRpbmcsIGFyZV95b3VfZ29pbmdfYWN0dWFsbHlfZ29pbmdfdHJpY2tfb3JfdHJlYXRpbmdfeW91cnNlbGYsIHdoaWNoX2NvdW50cnlfZG9feW91X2xpdmVfaW4pCmNhbmR5XzIwMTZfMwoKIyAyMDE3CmNhbmR5XzIwMTdfMyA8LSBjYW5keV8yMDE3XzIgJT4lCiAgc2VsZWN0KHEzX2FnZSwgY2FuZHlfbmFtZSwgcmF0aW5nLCBxMV9nb2luZ19vdXQsIHE0X2NvdW50cnkpCmNhbmR5XzIwMTdfMwoKCmBgYAoKCmBgYHtyfQojIFJlbmFtZSBjb2x1bW5zIHNvIHRoYXQgdGhleSBhbGlnbiBhY3Jvc3MgdGhlIDMgeWVhcnMgb2YgZGF0YQoKIyAyMDE1CmNhbmR5XzIwMTVfNCA8LSBjYW5keV8yMDE1XzMgJT4lCiAgcmVuYW1lKGFnZSA9ICJob3dfb2xkX2FyZV95b3UiLCAKICAgICAgICBjYW5keV9uYW1lID0gImNhbmR5X25hbWUiLAogICAgICAgIHJhdGluZyA9ICJyYXRpbmciLAogICAgICAgIHRyaWNrX29yX3RyZWF0aW5nID0gImFyZV95b3VfZ29pbmdfYWN0dWFsbHlfZ29pbmdfdHJpY2tfb3JfdHJlYXRpbmdfeW91cnNlbGYiKSAKbmFtZXMoY2FuZHlfMjAxNV80KQoKIyAyMDE2CmNhbmR5XzIwMTZfNCA8LSBjYW5keV8yMDE2XzMgJT4lCiAgcmVuYW1lKGFnZSA9ICJob3dfb2xkX2FyZV95b3UiLCAKICAgICAgICBjYW5keV9uYW1lID0gImNhbmR5X25hbWUiLAogICAgICAgIHJhdGluZyA9ICJyYXRpbmciLAogICAgICAgIHRyaWNrX29yX3RyZWF0aW5nID0gImFyZV95b3VfZ29pbmdfYWN0dWFsbHlfZ29pbmdfdHJpY2tfb3JfdHJlYXRpbmdfeW91cnNlbGYiLAogICAgICAgIGNvdW50cnkgPSAid2hpY2hfY291bnRyeV9kb195b3VfbGl2ZV9pbiIpCm5hbWVzKGNhbmR5XzIwMTZfNCkKCiMgMjAxNwpjYW5keV8yMDE3XzQgPC0gY2FuZHlfMjAxN18zICU+JQogIHJlbmFtZShhZ2UgPSAicTNfYWdlIiwgCiAgICAgICAgY2FuZHlfbmFtZSA9ICJjYW5keV9uYW1lIiwKICAgICAgICByYXRpbmcgPSAicmF0aW5nIiwKICAgICAgICB0cmlja19vcl90cmVhdGluZyA9ICJxMV9nb2luZ19vdXQiLAogICAgICAgIGNvdW50cnkgPSAicTRfY291bnRyeSIpCm5hbWVzKGNhbmR5XzIwMTdfNCkKCmBgYAoK